package indi.kane.simpleproject.dao;

import indi.kane.simpleproject.entity.Profession;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ProfessionMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Profession record);

    int insertSelective(Profession record);

    @Select("SELECT id,`name`,updated_by as updatedBy,updated_on as updatedOn FROM profession ORDER BY name ASC")
    List<Profession> loadAll();

    Profession selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Profession record);

    int updateByPrimaryKey(Profession record);
}